Alias

/* calculated discount column name is called 'discount' */
SELECT *, price * .10 AS discount FROM cars;